-
Re: Parent Health Status of Children Rows Based On If Certain Criteria Is Met
If you are using hierarchy, you can do the following formula: =IF(COUNTIF(CHILDREN(), "Female") = 0, "Red") If you are not using hierarchy and have a range, you can use: =IF(COUNT…1 ·